libname hercules 's:\courses\stat-renaes\stat426\data1';

proc contents data=Hercules.nonsales;
run;

title 'Data that has issues';
proc print data=hercules.nonsales;
run;

title 'Cleaned Countries';
data work.clean;
   set hercules.nonsales; 
   Country=upcase(Country);
run;
proc print data=work.clean;
   var Employee_ID Job_Title Country;
run;

title "Cleaned Countries and Salaries 1";
data work.clean;
   set hercules.nonsales; 
   Country=upcase(Country);
   if Employee_ID=120106 then Salary=26960;
   if Employee_ID=120115 then Salary=26500;
   if Employee_ID=120191 then Salary=24015;
run;
proc print data=work.clean;
   var Employee_ID Salary Job_Title Country;
run;

title 'Cleaned Countries and Salaries 2';
data work.clean;
   set hercules.nonsales; 
   Country=upcase(Country);
   if Employee_ID=120106 then Salary=26960;
   	else if Employee_ID=120115 then Salary=26500;
   	else if Employee_ID=120191 then Salary=24015;
run;
proc print data=work.clean;
   var Employee_ID Salary Job_Title Country;
run;